Projects

Data Analysis - Virtual Experience Projects

  • NSW Government (Jul 2021 - Aug 2021): analysis of employment arrangements, age, diversity of workforce to support policy development using Excel Pivot Table
  • Ampol Business Analyst (Apr 2021 - May 2021): profit optimisation with Excel Solver
April 2021 - December 2021

Attention-based stocks tracking on Australian Securities Exchange (ASX)

Personal Project
  • Tracked real-time attention-based stocks on ASX
  • Queried data from Google Finance database (delayed by 20 minutes) and tradingview.com (#1 traffic website for investing worldwide)
  • Analysed using Google Sheets (Dynamic Array, VLOOKUP, INDEX, SUMPRODUCT, … functions) and monitored market attention for 11 sectors and 24 industry groups of ASX
August 2021 - October 2021

Products sourcing analysis – Toy industry – Amazon Australia

Personal Project
  • Sourced products prices from other retailers' website using Octoparse software, then upgraded to self-developed Python script for more functions
November 2019 - Present

Australian vitamin & supplements

Personal Project
  • Collected data from Chemist Warehouse website using Google Sheets macros and IMPORTXML function
  • Cleaned, analysed, and identified the discounted products for sale
July 2018 - Present

Volunteer

Mentor – Be My Mentee – AP Project

Trained soft skills, personal development and goal setting skills to mentees (high school students) in 1 year.

July 2018 - July 2019